/*
 Navicat Premium Data Transfer

 Source Server         : HOST
 Source Server Type    : MySQL
 Source Server Version : 80023
 Source Host           : localhost:3306
 Source Schema         : temp_location

 Target Server Type    : MySQL
 Target Server Version : 80023
 File Encoding         : 65001

 Date: 18/11/2021 11:57:39
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sys_region
-- ----------------------------
DROP TABLE IF EXISTS `sys_region`;
CREATE TABLE `sys_region` (
  `id` int NOT NULL COMMENT '区域主键',
  `name` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '区域名称',
  `pid` int DEFAULT NULL COMMENT '区域上级标识',
  `sname` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '地名简称',
  `level` int DEFAULT NULL COMMENT '区域等级',
  `citycode` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '区域编码',
  `postcode` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '邮政编码',
  `mername` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '组合名称',
  `lng` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '经度',
  `lat` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '纬度',
  `pinyin` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '拼音',
  `gmt_create` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `status` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '0' COMMENT '状态 0正常 1停用',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT COMMENT='地区表';

-- ----------------------------
-- Records of sys_region
-- ----------------------------
BEGIN;
INSERT INTO `sys_region` VALUES (1, '郑州', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2021-11-18 03:55:15', '2021-11-18 03:55:15', '0');
INSERT INTO `sys_region` VALUES (2, '信阳', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2021-11-18 03:42:24', '2021-11-18 03:42:24', '0');
INSERT INTO `sys_region` VALUES (3, '固始', 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2021-11-18 03:42:38', '2021-11-18 03:42:38', '0');
INSERT INTO `sys_region` VALUES (4, '商城', 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2021-11-18 03:42:52', '2021-11-18 03:42:52', '0');
INSERT INTO `sys_region` VALUES (5, '淮滨', 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2021-11-18 03:43:04', '2021-11-18 03:43:04', '0');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
